Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	8636
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.6 MiB
Average record size in memory	190.6 B

Variable types

Numeric	18
Categorical	1

Alerts

`balance` is highly overall correlated with `balance_freq` and 5 other fields	High correlation
`balance_freq` is highly overall correlated with `balance` and 1 other fields	High correlation
`purchases` is highly overall correlated with `one_purchases` and 5 other fields	High correlation
`one_purchases` is highly overall correlated with `purchases` and 2 other fields	High correlation
`install_purchases` is highly overall correlated with `purchases` and 3 other fields	High correlation
`cash_adv` is highly overall correlated with `balance` and 2 other fields	High correlation
`purchases_freq` is highly overall correlated with `purchases` and 3 other fields	High correlation
`one_purchases_freq` is highly overall correlated with `purchases` and 2 other fields	High correlation
`purchases_install_freq` is highly overall correlated with `purchases` and 3 other fields	High correlation
`cash_adv_freq` is highly overall correlated with `balance` and 2 other fields	High correlation
`cash_adv_trx` is highly overall correlated with `balance` and 2 other fields	High correlation
`purchases_trx` is highly overall correlated with `purchases` and 5 other fields	High correlation
`payments` is highly overall correlated with `outliers`	High correlation
`min_pay` is highly overall correlated with `balance` and 1 other fields	High correlation
`prc_full_pay` is highly overall correlated with `balance`	High correlation
`outliers` is highly overall correlated with `payments`	High correlation
`outliers` is highly imbalanced (53.1%)	Imbalance
`id` is uniformly distributed	Uniform
`id` has unique values	Unique
`payments` has unique values	Unique
`purchases` has 1967 (22.8%) zeros	Zeros
`one_purchases` has 4113 (47.6%) zeros	Zeros
`install_purchases` has 3747 (43.4%) zeros	Zeros
`cash_adv` has 4431 (51.3%) zeros	Zeros
`purchases_freq` has 1966 (22.8%) zeros	Zeros
`one_purchases_freq` has 4113 (47.6%) zeros	Zeros
`purchases_install_freq` has 3746 (43.4%) zeros	Zeros
`cash_adv_freq` has 4431 (51.3%) zeros	Zeros
`cash_adv_trx` has 4431 (51.3%) zeros	Zeros
`purchases_trx` has 1967 (22.8%) zeros	Zeros
`prc_full_pay` has 5589 (64.7%) zeros	Zeros

Reproduction

Analysis started	2023-01-26 18:40:55.682759
Analysis finished	2023-01-26 18:41:47.076482
Duration	51.39 seconds
Software version	pandas-profiling vv3.6.2
Download configuration	config.json

id
Real number (ℝ)

UNIFORM UNIQUE

Distinct	8636
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14602.541

Minimum	10001
Maximum	19190
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	10001
5-th percentile	10487.75
Q1	12337.75
median	14592.5
Q3	16885.25
95-th percentile	18719.25
Maximum	19190
Range	9189
Interquartile range (IQR)	4547.5

Descriptive statistics

Standard deviation	2632.7728
Coefficient of variation (CV)	0.18029552
Kurtosis	-1.1887838
Mean	14602.541
Median Absolute Deviation (MAD)	2273.5
Skewness	0.002493971
Sum	1.2610754 × 10⁸
Variance	6931492.4
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10001	1	< 0.1%
16111	1	< 0.1%
16125	1	< 0.1%
16124	1	< 0.1%
16123	1	< 0.1%
16122	1	< 0.1%
16121	1	< 0.1%
16120	1	< 0.1%
16119	1	< 0.1%
16118	1	< 0.1%
Other values (8626)	8626	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10001	1	< 0.1%
10002	1	< 0.1%
10003	1	< 0.1%
10005	1	< 0.1%
10006	1	< 0.1%
10007	1	< 0.1%
10008	1	< 0.1%
10009	1	< 0.1%
10010	1	< 0.1%
10011	1	< 0.1%

Value	Count	Frequency (%)
19190	1	< 0.1%
19189	1	< 0.1%
19188	1	< 0.1%
19186	1	< 0.1%
19184	1	< 0.1%
19183	1	< 0.1%
19182	1	< 0.1%
19181	1	< 0.1%
19180	1	< 0.1%
19179	1	< 0.1%

balance
Real number (ℝ)

Distinct	8631
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1601.2249

Minimum	0
Maximum	19043.139
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	13.209472
Q1	148.09519
median	916.85546
Q3	2105.1959
95-th percentile	5936.6356
Maximum	19043.139
Range	19043.139
Interquartile range (IQR)	1957.1007

Descriptive statistics

Standard deviation	2095.5713
Coefficient of variation (CV)	1.3087302
Kurtosis	7.553876
Mean	1601.2249
Median Absolute Deviation (MAD)	825.60645
Skewness	2.3742542
Sum	13828178
Variance	4391419.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6	0.1%
40.900749	1	< 0.1%
1253.188317	1	< 0.1%
394.643543	1	< 0.1%
617.413726	1	< 0.1%
765.109593	1	< 0.1%
2583.247881	1	< 0.1%
1146.669364	1	< 0.1%
757.470201	1	< 0.1%
5058.299635	1	< 0.1%
Other values (8621)	8621	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6	0.1%
0.000199	1	< 0.1%
0.001146	1	< 0.1%
0.001214	1	< 0.1%
0.001289	1	< 0.1%
0.004816	1	< 0.1%
0.009684	1	< 0.1%
0.064811	1	< 0.1%
0.065402	1	< 0.1%
0.074724	1	< 0.1%

Value	Count	Frequency (%)
19043.13856	1	< 0.1%
18495.55855	1	< 0.1%
16304.88925	1	< 0.1%
16259.44857	1	< 0.1%
16115.5964	1	< 0.1%
15532.33972	1	< 0.1%
15258.2259	1	< 0.1%
15244.74865	1	< 0.1%
15155.53286	1	< 0.1%
14581.45914	1	< 0.1%

balance_freq
Real number (ℝ)

Distinct	42
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.89503511

Minimum	0
Maximum	1
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.363636
Q1	0.909091
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.090909

Descriptive statistics

Standard deviation	0.20769688
Coefficient of variation (CV)	0.23205444
Kurtosis	3.3695861
Mean	0.89503511
Median Absolute Deviation (MAD)	0
Skewness	-2.0841615
Sum	7729.5232
Variance	0.043137992
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
1	6130	71.0%
0.909091	406	4.7%
0.818182	274	3.2%
0.727273	220	2.5%
0.545455	217	2.5%
0.636364	202	2.3%
0.454545	170	2.0%
0.363636	167	1.9%
0.272727	141	1.6%
0.181818	117	1.4%
Other values (32)	592	6.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6	0.1%
0.090909	25	0.3%
0.1	2	< 0.1%
0.125	2	< 0.1%
0.142857	1	< 0.1%
0.166667	1	< 0.1%
0.181818	117	1.4%
0.2	7	0.1%
0.222222	2	< 0.1%
0.25	5	0.1%

Value	Count	Frequency (%)
1	6130	71.0%
0.909091	406	4.7%
0.9	55	0.6%
0.888889	53	0.6%
0.875	57	0.7%
0.857143	50	0.6%
0.833333	59	0.7%
0.818182	274	3.2%
0.8	20	0.2%
0.777778	21	0.2%

purchases
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	6015
Distinct (%)	69.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1025.4339

Minimum	0
Maximum	49039.57
Zeros	1967
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	43.3675
median	375.405
Q3	1145.98
95-th percentile	4060.0925
Maximum	49039.57
Range	49039.57
Interquartile range (IQR)	1102.6125

Descriptive statistics

Standard deviation	2167.108
Coefficient of variation (CV)	2.1133571
Kurtosis	108.67768
Mean	1025.4339
Median Absolute Deviation (MAD)	375.405
Skewness	8.055789
Sum	8855646.9
Variance	4696357
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1967	22.8%
45.65	25	0.3%
150	15	0.2%
60	13	0.2%
200	12	0.1%
450	12	0.1%
100	12	0.1%
600	10	0.1%
70	10	0.1%
1000	9	0.1%
Other values (6005)	6551	75.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1967	22.8%
0.01	3	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
1	2	< 0.1%
2	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
4.99	1	< 0.1%
6.9	1	< 0.1%

Value	Count	Frequency (%)
49039.57	1	< 0.1%
41050.4	1	< 0.1%
40040.71	1	< 0.1%
38902.71	1	< 0.1%
35131.16	1	< 0.1%
32539.78	1	< 0.1%
31299.35	1	< 0.1%
27957.68	1	< 0.1%
27790.42	1	< 0.1%
26784.62	1	< 0.1%

one_purchases
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	3922
Distinct (%)	45.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	604.90144

Minimum	0
Maximum	40761.25
Zeros	4113
Zeros (%)	47.6%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	44.995
Q3	599.1
95-th percentile	2728.3725
Maximum	40761.25
Range	40761.25
Interquartile range (IQR)	599.1

Descriptive statistics

Standard deviation	1684.3078
Coefficient of variation (CV)	2.7844335
Kurtosis	160.12131
Mean	604.90144
Median Absolute Deviation (MAD)	44.995
Skewness	9.9357759
Sum	5223928.8
Variance	2836892.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4113	47.6%
45.65	43	0.5%
50	16	0.2%
200	15	0.2%
70	12	0.1%
150	12	0.1%
1000	12	0.1%
100	12	0.1%
250	11	0.1%
60	10	0.1%
Other values (3912)	4380	50.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4113	47.6%
0.01	6	0.1%
0.02	2	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
1	4	< 0.1%
1.4	1	< 0.1%
2	1	< 0.1%
4.99	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
40761.25	1	< 0.1%
40624.06	1	< 0.1%
34087.73	1	< 0.1%
33803.84	1	< 0.1%
26547.43	1	< 0.1%
26514.32	1	< 0.1%
25122.77	1	< 0.1%
24543.52	1	< 0.1%
23032.97	1	< 0.1%
22257.39	1	< 0.1%

install_purchases
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4341
Distinct (%)	50.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	420.84353

Minimum	0
Maximum	22500
Zeros	3747
Zeros (%)	43.4%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	94.785
Q3	484.1475
95-th percentile	1800
Maximum	22500
Range	22500
Interquartile range (IQR)	484.1475

Descriptive statistics

Standard deviation	917.24518
Coefficient of variation (CV)	2.1795397
Kurtosis	94.193373
Mean	420.84353
Median Absolute Deviation (MAD)	94.785
Skewness	7.2161333
Sum	3634404.8
Variance	841338.72
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3747	43.4%
100	14	0.2%
200	13	0.2%
125	11	0.1%
150	11	0.1%
300	10	0.1%
75	9	0.1%
450	8	0.1%
500	8	0.1%
270	7	0.1%
Other values (4331)	4798	55.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3747	43.4%
1.95	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
6.33	1	< 0.1%
7.26	1	< 0.1%
7.67	1	< 0.1%
9.58	1	< 0.1%
9.65	1	< 0.1%
9.68	1	< 0.1%

Value	Count	Frequency (%)
22500	1	< 0.1%
15497.19	1	< 0.1%
14686.1	1	< 0.1%
13184.43	1	< 0.1%
12738.47	1	< 0.1%
12560.85	1	< 0.1%
12541	1	< 0.1%
12375	1	< 0.1%
12235.05	1	< 0.1%
12128.94	1	< 0.1%

cash_adv
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4206
Distinct (%)	48.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	994.17552

Minimum	0
Maximum	47137.212
Zeros	4431
Zeros (%)	51.3%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1132.3855
95-th percentile	4721.4155
Maximum	47137.212
Range	47137.212
Interquartile range (IQR)	1132.3855

Descriptive statistics

Standard deviation	2121.4583
Coefficient of variation (CV)	2.1338871
Kurtosis	52.143523
Mean	994.17552
Median Absolute Deviation (MAD)	0
Skewness	5.1396286
Sum	8585699.8
Variance	4500585.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4431	51.3%
2411.584248	1	< 0.1%
92.6579	1	< 0.1%
1486.243293	1	< 0.1%
855.232779	1	< 0.1%
3767.104707	1	< 0.1%
291.608512	1	< 0.1%
38.690552	1	< 0.1%
521.664369	1	< 0.1%
1974.202963	1	< 0.1%
Other values (4196)	4196	48.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4431	51.3%
14.222216	1	< 0.1%
18.042768	1	< 0.1%
18.117967	1	< 0.1%
18.123413	1	< 0.1%
18.126683	1	< 0.1%
18.149946	1	< 0.1%
18.204577	1	< 0.1%
18.240626	1	< 0.1%
18.280043	1	< 0.1%

Value	Count	Frequency (%)
47137.21176	1	< 0.1%
29282.10915	1	< 0.1%
27296.48576	1	< 0.1%
26268.69989	1	< 0.1%
26194.04954	1	< 0.1%
23130.82106	1	< 0.1%
22665.7785	1	< 0.1%
21943.84942	1	< 0.1%
20712.67008	1	< 0.1%
20277.33112	1	< 0.1%

purchases_freq
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.496

Minimum	0
Maximum	1
Zeros	1966
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.083333
median	0.5
Q3	0.916667
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.833334

Descriptive statistics

Standard deviation	0.40127264
Coefficient of variation (CV)	0.80901742
Kurtosis	-1.6380013
Mean	0.496
Median Absolute Deviation (MAD)	0.416667
Skewness	0.033041216
Sum	4283.456
Variance	0.16101973
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	2126	24.6%
0	1966	22.8%
0.083333	622	7.2%
0.916667	391	4.5%
0.5	390	4.5%
0.833333	367	4.2%
0.166667	367	4.2%
0.333333	350	4.1%
0.25	328	3.8%
0.583333	309	3.6%
Other values (37)	1420	16.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1966	22.8%
0.083333	622	7.2%
0.090909	41	0.5%
0.1	23	0.3%
0.111111	16	0.2%
0.125	25	0.3%
0.142857	22	0.3%
0.166667	367	4.2%
0.181818	15	0.2%
0.2	17	0.2%

Value	Count	Frequency (%)
1	2126	24.6%
0.916667	391	4.5%
0.909091	28	0.3%
0.9	23	0.3%
0.888889	18	0.2%
0.875	26	0.3%
0.857143	23	0.3%
0.833333	367	4.2%
0.818182	20	0.2%
0.8	9	0.1%

one_purchases_freq
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.20590874

Minimum	0
Maximum	1
Zeros	4113
Zeros (%)	47.6%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.083333
Q3	0.333333
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.333333

Descriptive statistics

Standard deviation	0.30005361
Coefficient of variation (CV)	1.4572165
Kurtosis	1.0582057
Mean	0.20590874
Median Absolute Deviation (MAD)	0.083333
Skewness	1.5042342
Sum	1778.2279
Variance	0.090032167
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	4113	47.6%
0.083333	1057	12.2%
0.166667	576	6.7%
1	469	5.4%
0.25	408	4.7%
0.333333	346	4.0%
0.416667	243	2.8%
0.5	232	2.7%
0.583333	197	2.3%
0.666667	167	1.9%
Other values (37)	828	9.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4113	47.6%
0.083333	1057	12.2%
0.090909	54	0.6%
0.1	36	0.4%
0.111111	24	0.3%
0.125	35	0.4%
0.142857	33	0.4%
0.166667	576	6.7%
0.181818	33	0.4%
0.2	26	0.3%

Value	Count	Frequency (%)
1	469	5.4%
0.916667	151	1.7%
0.909091	4	< 0.1%
0.9	1	< 0.1%
0.888889	2	< 0.1%
0.875	6	0.1%
0.857143	1	< 0.1%
0.833333	115	1.3%
0.818182	10	0.1%
0.8	4	< 0.1%

purchases_install_freq
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.36882035

Minimum	0
Maximum	1
Zeros	3746
Zeros (%)	43.4%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.166667
Q3	0.75
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.39809294
Coefficient of variation (CV)	1.0793682
Kurtosis	-1.4192794
Mean	0.36882035
Median Absolute Deviation (MAD)	0.166667
Skewness	0.48775295
Sum	3185.1325
Variance	0.15847799
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	3746	43.4%
1	1297	15.0%
0.416667	381	4.4%
0.916667	340	3.9%
0.833333	304	3.5%
0.5	303	3.5%
0.166667	296	3.4%
0.666667	290	3.4%
0.75	284	3.3%
0.083333	249	2.9%
Other values (37)	1146	13.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3746	43.4%
0.083333	249	2.9%
0.090909	10	0.1%
0.1	5	0.1%
0.111111	8	0.1%
0.125	4	< 0.1%
0.142857	5	0.1%
0.166667	296	3.4%
0.181818	14	0.2%
0.2	8	0.1%

Value	Count	Frequency (%)
1	1297	15.0%
0.916667	340	3.9%
0.909091	25	0.3%
0.9	18	0.2%
0.888889	28	0.3%
0.875	28	0.3%
0.857143	29	0.3%
0.833333	304	3.5%
0.818182	20	0.2%
0.8	17	0.2%

cash_adv_freq
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	54
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1376042

Minimum	0
Maximum	1.5
Zeros	4431
Zeros (%)	51.3%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.25
95-th percentile	0.583333
Maximum	1.5
Range	1.5
Interquartile range (IQR)	0.25

Descriptive statistics

Standard deviation	0.20179143
Coefficient of variation (CV)	1.4664627
Kurtosis	3.1842333
Mean	0.1376042
Median Absolute Deviation (MAD)	0
Skewness	1.795915
Sum	1188.3499
Variance	0.040719781
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4431	51.3%
0.083333	980	11.3%
0.166667	730	8.5%
0.25	573	6.6%
0.333333	434	5.0%
0.416667	272	3.1%
0.5	209	2.4%
0.583333	142	1.6%
0.666667	124	1.4%
0.090909	66	0.8%
Other values (44)	675	7.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4431	51.3%
0.083333	980	11.3%
0.090909	66	0.8%
0.1	36	0.4%
0.111111	23	0.3%
0.125	43	0.5%
0.142857	43	0.5%
0.166667	730	8.5%
0.181818	41	0.5%
0.2	21	0.2%

Value	Count	Frequency (%)
1.5	1	< 0.1%
1.25	1	< 0.1%
1.166667	2	< 0.1%
1.142857	1	< 0.1%
1.125	1	< 0.1%
1.1	1	< 0.1%
1.090909	1	< 0.1%
1	24	0.3%
0.916667	27	0.3%
0.909091	3	< 0.1%

cash_adv_trx
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	65
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3139185

Minimum	0
Maximum	123
Zeros	4431
Zeros (%)	51.3%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	15
Maximum	123
Range	123
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	6.9125061
Coefficient of variation (CV)	2.0859011
Kurtosis	60.428523
Mean	3.3139185
Median Absolute Deviation (MAD)	0
Skewness	5.6733268
Sum	28619
Variance	47.782741
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4431	51.3%
1	839	9.7%
2	602	7.0%
3	429	5.0%
4	374	4.3%
5	300	3.5%
6	241	2.8%
7	202	2.3%
8	169	2.0%
10	147	1.7%
Other values (55)	902	10.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4431	51.3%
1	839	9.7%
2	602	7.0%
3	429	5.0%
4	374	4.3%
5	300	3.5%
6	241	2.8%
7	202	2.3%
8	169	2.0%
9	108	1.3%

Value	Count	Frequency (%)
123	3	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
93	1	< 0.1%
80	1	< 0.1%
71	1	< 0.1%
69	1	< 0.1%
63	1	< 0.1%
62	3	< 0.1%
61	1	< 0.1%

purchases_trx
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	173
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.033233

Minimum	0
Maximum	358
Zeros	1967
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	7
Q3	18
95-th percentile	59
Maximum	358
Range	358
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	25.180468
Coefficient of variation (CV)	1.6749869
Kurtosis	33.952279
Mean	15.033233
Median Absolute Deviation (MAD)	7
Skewness	4.5784185
Sum	129827
Variance	634.05599
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1967	22.8%
1	606	7.0%
12	537	6.2%
2	345	4.0%
6	340	3.9%
3	294	3.4%
4	277	3.2%
7	265	3.1%
8	263	3.0%
5	254	2.9%
Other values (163)	3488	40.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1967	22.8%
1	606	7.0%
2	345	4.0%
3	294	3.4%
4	277	3.2%
5	254	2.9%
6	340	3.9%
7	265	3.1%
8	263	3.0%
9	240	2.8%

Value	Count	Frequency (%)
358	1	< 0.1%
347	1	< 0.1%
344	1	< 0.1%
309	1	< 0.1%
308	1	< 0.1%
298	1	< 0.1%
274	1	< 0.1%
273	1	< 0.1%
254	1	< 0.1%
248	2	< 0.1%

credit_limit
Real number (ℝ)

Distinct	203
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4522.091

Minimum	50
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	50
5-th percentile	1000
Q1	1600
median	3000
Q3	6500
95-th percentile	12000
Maximum	30000
Range	29950
Interquartile range (IQR)	4900

Descriptive statistics

Standard deviation	3659.2404
Coefficient of variation (CV)	0.80919211
Kurtosis	2.7734731
Mean	4522.091
Median Absolute Deviation (MAD)	1800
Skewness	1.507019
Sum	39052778
Variance	13390040
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3000	752	8.7%
1500	695	8.0%
1200	597	6.9%
1000	596	6.9%
2500	584	6.8%
4000	471	5.5%
6000	449	5.2%
5000	370	4.3%
2000	364	4.2%
7500	273	3.2%
Other values (193)	3485	40.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
50	1	< 0.1%
150	5	0.1%
200	3	< 0.1%
300	14	0.2%
400	3	< 0.1%
450	6	0.1%
500	112	1.3%
600	21	0.2%
650	1	< 0.1%
700	20	0.2%

Value	Count	Frequency (%)
30000	2	< 0.1%
28000	1	< 0.1%
25000	1	< 0.1%
23000	2	< 0.1%
22500	1	< 0.1%
22000	1	< 0.1%
21500	2	< 0.1%
21000	2	< 0.1%
20500	1	< 0.1%
20000	10	0.1%

payments
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	8636
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1784.4781

Minimum	0.049513
Maximum	50721.483
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0.049513
5-th percentile	143.55957
Q1	418.55924
median	896.6757
Q3	1951.1421
95-th percentile	6152.3187
Maximum	50721.483
Range	50721.434
Interquartile range (IQR)	1532.5829

Descriptive statistics

Standard deviation	2909.8101
Coefficient of variation (CV)	1.6306225
Kurtosis	54.270814
Mean	1784.4781
Median Absolute Deviation (MAD)	592.62252
Skewness	5.8730486
Sum	15410753
Variance	8466994.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
201.802084	1	< 0.1%
6372.619037	1	< 0.1%
162.949236	1	< 0.1%
164.403739	1	< 0.1%
1679.00486	1	< 0.1%
209.392729	1	< 0.1%
1014.549633	1	< 0.1%
272.517748	1	< 0.1%
32.924384	1	< 0.1%
1899.738286	1	< 0.1%
Other values (8626)	8626	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.049513	1	< 0.1%
0.056466	1	< 0.1%
3.500505	1	< 0.1%
4.523555	1	< 0.1%
4.841543	1	< 0.1%
9.533313	1	< 0.1%
12.773144	1	< 0.1%
14.500688	1	< 0.1%
16.385421	1	< 0.1%
18.125527	1	< 0.1%

Value	Count	Frequency (%)
50721.48336	1	< 0.1%
46930.59824	1	< 0.1%
40627.59524	1	< 0.1%
39461.9658	1	< 0.1%
39048.59762	1	< 0.1%
36066.75068	1	< 0.1%
35843.62593	1	< 0.1%
34107.07499	1	< 0.1%
33994.72785	1	< 0.1%
33486.31044	1	< 0.1%

min_pay
Real number (ℝ)

Distinct	8635
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	864.30494

Minimum	0.019163
Maximum	76406.208
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0.019163
5-th percentile	73.358542
Q1	169.16355
median	312.45229
Q3	825.49646
95-th percentile	2766.5939
Maximum	76406.208
Range	76406.188
Interquartile range (IQR)	656.33292

Descriptive statistics

Standard deviation	2372.5664
Coefficient of variation (CV)	2.745057
Kurtosis	283.96304
Mean	864.30494
Median Absolute Deviation (MAD)	190.37279
Skewness	13.622193
Sum	7464137.5
Variance	5629071.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
299.351881	2	< 0.1%
342.28649	1	< 0.1%
184.464721	1	< 0.1%
276.486072	1	< 0.1%
309.140865	1	< 0.1%
354.281114	1	< 0.1%
216.090433	1	< 0.1%
277.546713	1	< 0.1%
150.317143	1	< 0.1%
1600.26917	1	< 0.1%
Other values (8625)	8625	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.019163	1	< 0.1%
0.037744	1	< 0.1%
0.05588	1	< 0.1%
0.059481	1	< 0.1%
0.117036	1	< 0.1%
0.261984	1	< 0.1%
0.311953	1	< 0.1%
0.319475	1	< 0.1%
1.113027	1	< 0.1%
1.334075	1	< 0.1%

Value	Count	Frequency (%)
76406.20752	1	< 0.1%
61031.6186	1	< 0.1%
56370.04117	1	< 0.1%
50260.75947	1	< 0.1%
43132.72823	1	< 0.1%
42629.55117	1	< 0.1%
38512.12477	1	< 0.1%
31871.36379	1	< 0.1%
30528.4324	1	< 0.1%
29019.80288	1	< 0.1%

prc_full_pay
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.15930362

Minimum	0
Maximum	1
Zeros	5589
Zeros (%)	64.7%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.166667
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.166667

Descriptive statistics

Standard deviation	0.29627091
Coefficient of variation (CV)	1.8597876
Kurtosis	2.2015985
Mean	0.15930362
Median Absolute Deviation (MAD)	0
Skewness	1.8860271
Sum	1375.7461
Variance	0.087776452
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	5589	64.7%
1	488	5.7%
0.083333	426	4.9%
0.166667	166	1.9%
0.5	156	1.8%
0.25	156	1.8%
0.090909	153	1.8%
0.333333	134	1.6%
0.1	94	1.1%
0.2	83	1.0%
Other values (37)	1191	13.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5589	64.7%
0.083333	426	4.9%
0.090909	153	1.8%
0.1	94	1.1%
0.111111	61	0.7%
0.125	52	0.6%
0.142857	54	0.6%
0.166667	166	1.9%
0.181818	75	0.9%
0.2	83	1.0%

Value	Count	Frequency (%)
1	488	5.7%
0.916667	77	0.9%
0.909091	19	0.2%
0.9	16	0.2%
0.888889	12	0.1%
0.875	18	0.2%
0.857143	12	0.1%
0.833333	63	0.7%
0.818182	17	0.2%
0.8	33	0.4%

tenure
Real number (ℝ)

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.534391

Minimum	6
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	134.9 KiB

Quantile statistics

Minimum	6
5-th percentile	8
Q1	12
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3109837
Coefficient of variation (CV)	0.11365868
Kurtosis	8.1567014
Mean	11.534391
Median Absolute Deviation (MAD)	0
Skewness	-3.0111405
Sum	99611
Variance	1.7186782
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
12	7346	85.1%
11	356	4.1%
10	226	2.6%
6	184	2.1%
8	183	2.1%
7	177	2.0%
9	164	1.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	184	2.1%
7	177	2.0%
8	183	2.1%
9	164	1.9%
10	226	2.6%
11	356	4.1%
12	7346	85.1%

Value	Count	Frequency (%)
12	7346	85.1%
11	356	4.1%
10	226	2.6%
9	164	1.9%
8	183	2.1%
7	177	2.0%
6	184	2.1%

outliers
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	134.9 KiB

1	7772
-1	864

Length

Max length	2
Median length	1
Mean length	1.1000463
Min length	1

Characters and Unicode

Total characters	9500
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	7772	90.0%
-1	864	10.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	8636	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	8636	90.9%
-	864	9.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	8636	90.9%
Dash Punctuation	864	9.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	8636	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	864	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	9500	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	8636	90.9%
-	864	9.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9500	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	8636	90.9%
-	864	9.1%

Auto

Heatmap
Table

	id	balance	balance_freq	purchases	one_purchases	install_purchases	cash_adv	purchases_freq	one_purchases_freq	purchases_install_freq	cash_adv_freq	cash_adv_trx	purchases_trx	credit_limit	payments	min_pay	prc_full_pay	tenure	outliers
id	1.000	-0.243	-0.121	-0.118	-0.187	-0.022	-0.047	-0.026	-0.181	0.019	-0.020	-0.022	-0.081	-0.375	-0.244	-0.205	0.059	-0.169	0.110
balance	-0.243	1.000	0.513	-0.013	0.130	-0.104	0.570	-0.163	0.103	-0.155	0.545	0.551	-0.064	0.378	0.419	0.900	-0.532	0.056	0.346
balance_freq	-0.121	0.513	1.000	0.128	0.116	0.117	0.129	0.195	0.141	0.152	0.167	0.167	0.189	0.099	0.161	0.502	-0.222	0.226	0.064
purchases	-0.118	-0.013	0.128	1.000	0.753	0.710	-0.387	0.794	0.694	0.609	-0.395	-0.388	0.886	0.263	0.398	-0.008	0.233	0.129	0.493
one_purchases	-0.187	0.130	0.116	0.753	1.000	0.208	-0.190	0.427	0.952	0.125	-0.185	-0.181	0.596	0.306	0.370	0.070	0.043	0.096	0.396
install_purchases	-0.022	-0.104	0.117	0.710	0.208	1.000	-0.358	0.786	0.191	0.922	-0.369	-0.360	0.784	0.127	0.234	-0.052	0.273	0.120	0.342
cash_adv	-0.047	0.570	0.129	-0.387	-0.190	-0.358	1.000	-0.454	-0.194	-0.378	0.940	0.951	-0.409	0.165	0.266	0.482	-0.280	-0.115	0.353
purchases_freq	-0.026	-0.163	0.195	0.794	0.427	0.786	-0.454	1.000	0.466	0.853	-0.455	-0.448	0.921	0.105	0.164	-0.104	0.292	0.091	0.159
one_purchases_freq	-0.181	0.103	0.141	0.694	0.952	0.191	-0.194	0.466	1.000	0.119	-0.182	-0.180	0.611	0.283	0.324	0.051	0.055	0.084	0.267
purchases_install_freq	0.019	-0.155	0.152	0.609	0.125	0.922	-0.378	0.853	0.119	1.000	-0.384	-0.376	0.780	0.050	0.112	-0.085	0.259	0.108	0.106
cash_adv_freq	-0.020	0.545	0.167	-0.395	-0.185	-0.369	0.940	-0.455	-0.182	-0.384	1.000	0.983	-0.410	0.090	0.202	0.456	-0.303	-0.133	0.325
cash_adv_trx	-0.022	0.551	0.167	-0.388	-0.181	-0.360	0.951	-0.448	-0.180	-0.376	0.983	1.000	-0.401	0.099	0.216	0.472	-0.297	-0.100	0.332
purchases_trx	-0.081	-0.064	0.189	0.886	0.596	0.784	-0.409	0.921	0.611	0.780	-0.410	-0.401	1.000	0.193	0.279	-0.025	0.247	0.163	0.401
credit_limit	-0.375	0.378	0.099	0.263	0.306	0.127	0.165	0.105	0.283	0.050	0.090	0.099	0.193	1.000	0.470	0.264	0.017	0.168	0.355
payments	-0.244	0.419	0.161	0.398	0.370	0.234	0.266	0.164	0.324	0.112	0.202	0.216	0.279	0.470	1.000	0.368	0.159	0.204	0.505
min_pay	-0.205	0.900	0.502	-0.008	0.070	-0.052	0.482	-0.104	0.051	-0.085	0.456	0.472	-0.025	0.264	0.368	1.000	-0.479	0.136	0.120
prc_full_pay	0.059	-0.532	-0.222	0.233	0.043	0.273	-0.280	0.292	0.055	0.259	-0.303	-0.297	0.247	0.017	0.159	-0.479	1.000	0.013	0.173
tenure	-0.169	0.056	0.226	0.129	0.096	0.120	-0.115	0.091	0.084	0.108	-0.133	-0.100	0.163	0.168	0.204	0.136	0.013	1.000	0.212
outliers	0.110	0.346	0.064	0.493	0.396	0.342	0.353	0.159	0.267	0.106	0.325	0.332	0.401	0.355	0.505	0.120	0.173	0.212	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id	balance	balance_freq	purchases	one_purchases	install_purchases	cash_adv	purchases_freq	one_purchases_freq	purchases_install_freq	cash_adv_freq	cash_adv_trx	purchases_trx	credit_limit	payments	min_pay	prc_full_pay	tenure	outliers
0	10001	40.900749	0.818182	95.40	0.00	95.40	0.000000	0.166667	0.000000	0.083333	0.00	0	2	1000.0	201.802084	139.509787	0.000000	12	1
1	10002	3202.467416	0.909091	0.00	0.00	0.00	6442.945483	0.000000	0.000000	0.000000	0.25	4	0	7000.0	4103.032597	1072.340217	0.222222	12	1
2	10003	2495.148862	1.000000	773.17	773.17	0.00	0.000000	1.000000	1.000000	0.000000	0.00	0	12	7500.0	622.066742	627.284787	0.000000	12	1
4	10005	817.714335	1.000000	16.00	16.00	0.00	0.000000	0.083333	0.083333	0.000000	0.00	0	1	1200.0	678.334763	244.791237	0.000000	12	1
5	10006	1809.828751	1.000000	1333.28	0.00	1333.28	0.000000	0.666667	0.000000	0.583333	0.00	0	8	1800.0	1400.057770	2407.246035	0.000000	12	1
6	10007	627.260806	1.000000	7091.01	6402.63	688.38	0.000000	1.000000	1.000000	1.000000	0.00	0	64	13500.0	6354.314328	198.065894	1.000000	12	-1
7	10008	1823.652743	1.000000	436.20	0.00	436.20	0.000000	1.000000	0.000000	1.000000	0.00	0	12	2300.0	679.065082	532.033990	0.000000	12	1
8	10009	1014.926473	1.000000	861.49	661.49	200.00	0.000000	0.333333	0.083333	0.250000	0.00	0	5	7000.0	688.278568	311.963409	0.000000	12	1
9	10010	152.225975	0.545455	1281.60	1281.60	0.00	0.000000	0.166667	0.166667	0.000000	0.00	0	3	11000.0	1164.770591	100.302262	0.000000	12	1
10	10011	1293.124939	1.000000	920.12	0.00	920.12	0.000000	1.000000	0.000000	1.000000	0.00	0	12	1200.0	1083.301007	2172.697765	0.000000	12	1

	id	balance	balance_freq	purchases	one_purchases	install_purchases	cash_adv	purchases_freq	one_purchases_freq	purchases_install_freq	cash_adv_freq	cash_adv_trx	purchases_trx	credit_limit	payments	min_pay	prc_full_pay	tenure	outliers
8938	19179	78.818407	0.500000	0.00	0.00	0.00	1113.186078	0.000000	0.000000	0.000000	0.166667	7	0	1200.0	1397.770131	21.821194	0.333333	6	-1
8939	19180	728.352548	1.000000	734.40	734.40	0.00	239.891038	0.333333	0.333333	0.000000	0.166667	2	2	1000.0	72.530037	110.950798	0.000000	6	1
8940	19181	130.838554	1.000000	591.24	0.00	591.24	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	475.523262	82.771320	1.000000	6	-1
8941	19182	5967.475270	0.833333	214.55	0.00	214.55	8555.409326	0.833333	0.000000	0.666667	0.666667	13	5	9000.0	966.202912	861.949906	0.000000	6	-1
8942	19183	40.829749	1.000000	113.28	0.00	113.28	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	94.488828	86.283101	0.250000	6	1
8943	19184	5.871712	0.500000	20.90	20.90	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	1	500.0	58.644883	43.473717	0.000000	6	1
8945	19186	28.493517	1.000000	291.12	0.00	291.12	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	325.594462	48.886365	0.500000	6	1
8947	19188	23.398673	0.833333	144.40	0.00	144.40	0.000000	0.833333	0.000000	0.666667	0.000000	0	5	1000.0	81.270775	82.418369	0.250000	6	1
8948	19189	13.457564	0.833333	0.00	0.00	0.00	36.558778	0.000000	0.000000	0.000000	0.166667	2	0	500.0	52.549959	55.755628	0.250000	6	1
8949	19190	372.708075	0.666667	1093.25	1093.25	0.00	127.040008	0.666667	0.666667	0.000000	0.333333	2	23	1200.0	63.165404	88.288956	0.000000	6	-1

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample